use vudu
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Juan
-- =============================================
CREATE PROCEDURE sp_periodos_activos 
		@id_pensum      int
AS
BEGIN
	SELECT RIGHT(CONVERT(VARCHAR(10), fechaInicio, 105), 7) AS [MM-YYYY],
	   RIGHT(CONVERT(VARCHAR(10), fechaFin,    105), 7) AS [MM-YYYY] 
	FROM PERIODOACADEMICO
	WHERE fk_id_pensum=@id_pensum 
END
GO
